package com.sinosoft.perfect.system._user;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.sinosoft.perfect.system._.po.TUser;
import com.sinosoft.perfect.system._.po.TUserImg;
import com.sinosoft.perfect.system._.po.TUserInformation;
import com.sinosoft.perfect.system._.po.TUserRolebusinessRelation;
import com.sinosoft.perfect.system._.po.TUserRolesysRelation;
import com.sinosoft.perfect.system._.po.TUserUnitRelation;
import com.sinosoft.perfect.system._user.formBean.UserForm;
import com.sinosoft.perfect.system._user.vo.UserStaticVO;
import com.sinosoft.perfect.system._user.vo.UserUnitVO;

public interface MapperSystemUser {

	public List<UserStaticVO> selectTUserStatic(UserStaticVO userStatic) throws SQLException;

	public Object insertTUserImg(TUserImg tuserimg) throws SQLException;

	public Object insertTUserUnit(TUserUnitRelation tuserunit) throws SQLException;

	public Object insertTUser(TUser tuser) throws SQLException;

	public Object insertTUserInfo(TUserInformation tuserinfo) throws SQLException;

	public Object insertTUserRoleBusiness(TUserRolebusinessRelation tuserrolebusiness) throws SQLException;

	public List<TUser> selectTUser(TUser tuser) throws SQLException;
	public List<TUser> selectTUsersInfoByUserids(String userids) throws SQLException;
	
	public List<TUserInformation> selectTUserInfo(TUserInformation tuserinfo) throws SQLException;

	public List<TUserImg> selectTUserImg(TUserImg tuserimg) throws SQLException;

	public List<UserForm> selectTUserFromUnit(UserForm userForm) throws SQLException;

	public List<UserForm> selectTUserFromRoleBusiness(UserForm userForm) throws SQLException;

	public Object selectExistTUser(UserForm userform) throws SQLException;

	public Object selectExistTUserPassword(TUser user) throws SQLException;

	public Object selectExistTUserFromUnit(Map<String, String> map) throws SQLException;

	public Object selectExistTUserFromRoleBusiness(Map<String, String> map) throws SQLException;

	public Object selectExistTUserForUpdate(TUser user) throws SQLException;

	public List<UserUnitVO> selectTUserAndTUnit(String unitId) throws SQLException;

	public List<TUser> selectTUserDetached(TUser tuser) throws SQLException;

	public Object selectTUserNameFromUserOrUserInfo(String userMainId) throws SQLException;

	public Object selectTUserSortNumFromUnit(Map<String, String> map) throws SQLException;

	public Object selectTUserMAXSortNumFromUnit(String unitId) throws SQLException;

	public Object selectTUserSortNumFromRoleBusiness(Map<String, String> map) throws SQLException;

	public Object selectTUserMAXSortNumFromRoleBusiness(String roleBusinessId) throws SQLException;

	public TUserUnitRelation selectTUserSortNumByLoginCode(Map<String, String> map) throws SQLException;

	public int updateTUserByPK(TUser tuser) throws SQLException;

	public int updateTUserInfoByPK(TUserInformation tuserinfo) throws SQLException;

	public int updateTUserImg(TUserImg tuserimg) throws SQLException;

	public int deleteTUserUnit(TUserUnitRelation tuserunit) throws SQLException;

	public int deleteTUserRoleBusiness(TUserRolebusinessRelation tuserrolebusiness) throws SQLException;

	public int deleteTUserRoleSystem(TUserRolesysRelation tUserRoleSystem) throws SQLException;

	public int deleteTUserImg(String userId) throws SQLException;

	public int deleteTUserInfo(String userId) throws SQLException;

	public int deleteTUser(String userId) throws SQLException;

	public List<UserForm> selectTUserFromRoleSystem(String roleSystemId) throws SQLException;

}
